package com.group3.hospital.mapper;

import com.group3.hospital.bean.Dep;
import com.group3.hospital.bean.Doctor;
import com.group3.hospital.bean.Subject;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author 秀秀
 */
public interface DoctorMapper {
    //查询非手术科室的全部科室
    List<Subject> querySubByDepId1() throws Exception;
    //查询手术科室的全部科室
    List<Subject> querySubByDepId2() throws Exception;
    //查询诊断科室的全部科室
    List<Subject> querySubByDepId3() throws Exception;


//    //根据具体科室的id查询该科室的全部医生
//    @Select("select doctor_name from doctor where subject_id = #{subjectId}")
//    List<Doctor> queryDocBySubId(Integer subjectId) throws Exception;


    //查询第一个具体科室的全部医生
    List<Doctor> queryDocByDepAndSub1() throws Exception;
    //查询第二个具体科室的全部医生
    List<Doctor> queryDocByDepAndSub2() throws Exception;
    //查询第三个具体科室的全部医生
    List<Doctor> queryDocByDepAndSub3() throws Exception;
}
